package jdbc.dao;

import jdbc.entity.Employee;

import java.util.List;

/**
 * @author Yancy
 * @program springioctest
 * @create 2021-01-23
 */
public interface EmployeeDao {

    /**
     * 添加员工
     * @param employee
     * @return  影响行数
     */
    int addEmployee(Employee employee);

    /**
     * 删除
     * @param empNo
     * @return
     */
    int deleteEmployee(int empNo);

    /**
     * 修改
     * @param employee
     * @return
     */
    int updateEmployee(Employee employee);

    /**
     * 查找
     * @param empNo
     * @return
     */
    Employee selectEmployee(int empNo);

    /**
     * 查找所有员工
     * @return
     */
    List<Employee> selAllEmployee();

}
